<%-- 
    Document   : myresumes
    Created on : Apr 4, 2012, 3:41:18 PM
    Author     : project
--%>
<%@include file="header.jsp" %>
<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%                     
                             
                 try {
                Connection con = Dbconn.getConn();
                Statement st = con.createStatement();
		String jobid=request.getParameter("jobid");
		String compname,jobtitle,walkindate,validuntil,funarea,jobrole,salary,salarytype,joblocation,jobdesc,keyskill,contname,contphone,contemail,desiredprof;
                String sql = "select * from jobs,company where jobid='"+ jobid +"' and jobs.compid=company.compid ";
                ResultSet rs = st.executeQuery(sql);
                    while(rs.next())
                   {

         


%>
<td height="auto" rowspan="4" align="left" valign="top" style="height:auto; padding:5px;">
       <div align="right" ></div> 
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr><td class="messagesred">
            </td></tr>
        <tr>
            <td><table width="100%" cellpadding="0" cellspacing="0" class="tbl_bdr">

                    <tr class="sde_mnu_hdr_blue">
                        <td width="22%" height="29" align="left" valign="middle"><strong>Job Title</strong></td>
                        <td width="12%" align="left" valign="middle"><strong>Posted on </strong></td>
                        <td width="52%" align="center" valign="middle"><strong>Action</strong></td>
                    </tr>

                    <tr>
                        <td height="28" align="left" valign="middle"  style="padding-left:5px;">Software</td>
                        <td align="left" valign="middle"  style="padding-left:5px;">2012-03-11 </td>
                        <td align="center" valign="middle"  style="padding-left:5px;">

                            <a href="student.jsp" class="link" target="_blank"><strong>Apply</strong></a>
                
                        </td>
                    </tr>

                </table></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td>	<div>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" >

                        <tr>
                            <td width="72%" ><span class="mainheading_js"><%=rs.getString("compname")%></span></td>
                        </tr>
                    </table>
                    <img src="./images/blank.gif" alt="blank" width="18" height="10" border="0" /><br>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">


                        <tr>
                            <td width="50%" height="20" align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="5" align="left" style="padding-left:5px;" class="sde_mnu_hdr_blue" ><img style="margin-top:2px; margin-left:-2px;" src="./images/top_left.gif"; class="sde_mnu_img2"/><strong>General Details </strong> </td>
                                    </tr>
                                    <tr>
                                        <td width="6%" height="20"  style="padding-left:5px;">&nbsp;</td>
                                        <td width="27%" align="left"  style="padding-left:2px;">Jobt Title</td>
                                        <td width="3%" align="center" >:</td>
                                        <td width="41%" align="left"  style="padding-left:5px; text-transform:capitalize;"><span style="padding-left:5px;"><%=rs.getString("jobtitle")%></span></td>
                                        <td width="23%" rowspan="5" align="center" valign="top"  style="padding-left:1px; padding-right:5px;">
                                            <img src="src/getpic.jsp?id=<%=rs.getString("compid")%>&table=company&col=logo&pk_col=compid" width="138" height="101" border="0" /></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Walkindate</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=rs.getString("walkindate")%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Validuntil</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=rs.getString("validuntil")%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Function Area</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=rs.getString("funarea")%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Job role</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=rs.getString("jobrole")%></td>
                                    </tr>
                                </table></td>
                          <td width="50%" align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                  <tr>
                                      <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="./images/top_left.gif"; class="sde_mnu_img2"/>Contact  Details </strong> </td>
                                  </tr>
                                  <tr>
                                      <td width="6%" height="20"  style="padding-left:5px;">&nbsp;</td>
                                      <td width="22%" align="left"  style="padding-left:2px;">Contact Person</td>
                                      <td width="4%" align="center" >:</td>
                                      <td width="68%" align="left"  style="padding-left:5px;"><%=rs.getString("contname")%></td>
                                  </tr>
                                  
                                  <tr>
                                      <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                      <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                      <td align="center" >&nbsp;</td>
                                      <td align="left"  style="padding-left:5px;">&nbsp;</td>
                                  </tr>
                                  
                                  <tr>
                                      <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                      <td height="22" align="left"  style="padding-left:2px;">Email</td>
                                      <td align="center" >:</td>
                                      <td align="left"  style="padding-left:5px;"><%=rs.getString("contemail")%><img src="./images/i_error.gif" /> </td>
                                  </tr>

                                  <tr>
                                    <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                    <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                    <td align="center" >&nbsp;</td>
                                    <td align="left"  style="padding-left:5px;">&nbsp;</td>
                                  </tr>
                                  <tr>
                                      <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                      <td height="22" align="left"  style="padding-left:2px;">Mobile</td>
                                      <td align="center" >:</td>
                                      <td align="left"  style="padding-left:5px;"><%=rs.getString("contphone")%><img src="./images/i_error.gif" /> </td>
                                  </tr>
                          </table></td>
                        </tr>
                        <tr>
                            <td height="5" colspan="2" align="center" valign="middle"></td>
                        </tr>

                        <tr>
                            <td height="5" colspan="2" align="center" valign="middle"></td>
                        </tr>
                        <tr>
                            <td height="20" align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="./images/top_left.gif"; class="sde_mnu_img2"/>Job Description</strong></td>
                                    </tr>
                                    <tr>
                                        <td width="5%" height="20"  style="padding-left:5px;">&nbsp;</td>
                                        
                                        
                                        <td width="53%" align="left"  style="padding-left:5px;"><%=rs.getString("jobdesc")%></td>
                                    </tr>
                                    

                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;"> Salary</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px; text-transform:capitalize;"><span style="padding-left:5px;"><span style="padding-left:5px;vertical-align:middle"><img src="./images/rupee.jpg" width="16" height="17"/></span><%=rs.getString("salary")%> INR.<%=rs.getString("salarytype")%></span></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;"> Experience </td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=rs.getString("minexp")%>-<%=rs.getString("maxexp")%> in Years.</td>
                                    </tr>

                          </table></td>
                            <td align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="./images/top_left.gif"; class="sde_mnu_img2"/>Desired Profile</strong> </td>
                                    </tr>
                                    
                                    <tr>
                                        <td width="53%" height="22" align="left"  style="padding-left:5px;"><%=rs.getString("desiredprof")%></td>
                                    </tr>


                          </table></td>

              
                        </tr>
                        <%             }  } catch (Exception e) {
                out.println("Exception::" + e);
            }
   %>
                        <div style="padding-top:15px;"><!-- --></div>
                        <tr>
                            <td height="20" align="center" valign="top" style="padding-left:5px; padding-left:5px;" colspan="2">



                                <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="./images/top_left.gif"; class="sde_mnu_img2"/>Academic   Details </strong> </td>
                                    </tr>

                                        <td height="22" align="left"  style="padding-left:2px;" width="3%">&nbsp;</td>
                                  </tr>
                                  <tr><td>&nbsp;</td></tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </div></td>
        </tr>
    </table>
</td>
<%@include file="footer.jsp"%>